-- @author lixiyong01
-- @date 2023.09.23
-- 数据治理-数据质量-基线检查报告

use hdp_lbg_supin_zplisting;

insert overwrite table app_zp_rock_dqc_sla_check_result_day partition (dt = '${#date(0,0,0):yyyyMMdd#}')
select
    task_config_id,
    check_table,
    owner_id,
    config_produce_time,
    real_produce_time,
    if(check_table in(
        'dm_zp_wb_n_flow',
        'dws_zp_wb_n_flow_action-yx_deduction',
        'dws_zp_wb_n_flow_action-search_mainpage',
        'app_zp_wb_n_flow_cube',
        'app_zp_gj_n_flow_cube',
        'dwd_zp_wb_n_search_rec',
        'dwd_zp_wb_n_infodetail',
        'dws_zp_wb_n_flow_action-im_connect',
        'dws_zp_wb_n_flow_action-infodetail'
    ), 'false', is_break) as is_break
from hdp_lbg_supin_zplisting.app_zp_rock_dqc_sla_check_result_day
where dt = '${#date(0,0,0):yyyyMMdd#}'